Designing Distributed Database Systems for Efficient Operation
نویسندگان
چکیده
Distributed database systems can yield significant cost and performance advantages over centralized systems for geographically distributed organizations. The efficiency of a distributed database depends primarily on the data allocation (data replication and placzment) and the operating strategies (where and how retrieval and update query processing operations are performed). We develop a distributed database design approach that comprehensively treats data allocation and operating strategies, explicitly modeling their interdependencies for both retrieval and updateprocessing. We demonstrate that data replication, join node selection, and data reduction by semijoin are important design and operating decisions that have significant impact on both the cost and response time of a distributed database system.
منابع مشابه
Transaction-Consistent Global Checkpoints in a Distributed Database System
Checkpointing and rollback recovery are well-known techniques for handling failures in distributed database systems. In this paper, we establish the necessary and sufficient conditions for the checkpoints on a set of data items to be part of a transaction-consistent global checkpoint of the distributed database. This can throw light on designing efficient, non-intrusive checkpointing techniques...
متن کاملSquare-root H2 and H∞ synthesis algorithms for sequentially semi-separable systems
We consider the problem of designing H2 and H∞ linear estimators for time-varying spatially interconnected systems distributed in one spatial dimension. In general, numerical implementation of the algebraic Riccati equation (ARE) solution for such systems is a complex and computationally expensive operation. However, the spatially interconnected systems can be described by state-space models wh...
متن کاملDesigning a comprehensive energy management strategy in a smart zero energy home
Smart homes with zero energy as an option to combine a large number of distributed energy resources to power networks in building a new future designs, are used. Zero energy homes equipped with smart power integrated production and consumption of zero over a year. In this study is that the sources of energy supply management program for a zero-energy home using mixed integer programming techniq...
متن کاملDesigning a comprehensive energy management strategy in a smart zero energy home
Smart homes with zero energy as an option to combine a large number of distributed energy resources to power networks in building a new future designs, are used. Zero energy homes equipped with smart power integrated production and consumption of zero over a year. In this study is that the sources of energy supply management program for a zero-energy home using mixed integer programming techniq...
متن کاملAn Optimal Skew-insensitive Join and Multi-join Algorithm for Distributed Architectures
The development of scalable parallel database systems requires the design of efficient algorithms for the join operation which is the most frequent and expensive operation in relational database systems. The join is also the most vulnerable operation to data skew and to the high cost of communication in distributed architectures. In this paper, we present a new parallel algorithm for join and m...
متن کامل